Entity Relationships - Assessor Details (ASSESSOR)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
ASSESSOR	Assessor Details	ASSESSORID				Stores basic details about each assessor, such as name, address, etc.
TRASSESSOR	Trainee-Assessor Link	TRAINEEID, TRASSID	TRAINEE	One to many	TRAINEEID	Table which links trainees to assessors.
EMPASSESSOR	Employer-Assessor Link	ASSESSORID, EMPASSID	ASSESSOR or EMPLOYER	One to many	ASSESSORID or EMPLOYERID	Table which links assessors to employers.
VISITS	Visits / Diary	VISID	ASSESSOR *	One to many	ASSESSORID	Stores visit information for assessors, trainees and employers. In this context, the table can join directly to the assessor record.
ASSMANAGER	Assessor-Manager	PARENTASSID, ASSMANID	ASSESSOR	Recursive	ASSESSORID = CHILDASSID or PARENTASSID	Stores the hierarchy of assessors. Each row stores a 'child' assessor (CHILDASSID) and a 'parent' assessor (PARENTASSID), which determines the hierarchy. Each assessor can have multiple rows in ASSMANAGER to reflect if they have multiple assessors who report to them, or if they have multiple assessors to whom they report.
TRMODULE	Trainee-Module Link	TRMODULEID, TRAINEEID	ASSESSOR	One to many	ASSESSORID	Links trainees to objectives. In this context, an assessor can be specified in TRMODULE to determine which of a trainee's modules they are assessing (e.g. when a trainee has multiple assessors).
ASSGENERALEVENTS	Assessor General Events	ASSESSORID, EVENTID	ASSESSOR	One to many	ASSESSORID	Links assessors to general events.

* Note on VISITS - The VISITS table stores visits for assessors, trainees and employers, and can join directly to the ASSESSOR, TRAINEE and EMPLOYER tables. In this context, the direct link between ASSESSOR and VISITS is effectively the assessor diary. It is also possible to join in a different way via trainees to see the visits associated with the trainees in an assessor's caseload: